<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<html>
<head>
<!--

 *************************************************************************
 * Copyright (c) 2004, 2006 Actuate Corporation.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v10.html
 *
 * Contributors:
 *  Actuate Corporation - initial API and implementation
 *  
 *************************************************************************

-->
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body bgcolor="white">

<h2>Package Specification</h2>
The Query-Text utilities serves as parsers that extract infomation from 
the saved query-text
<br>
<br>The standard format of the query text supported is specified below:
<p>
<b>SELECT "</b>originalColumn1<b>"</b> [<b>AS</b> alias1] [<b>,"</b>originalColumn2<b>"</b> [<b>AS</b> alias2]]... [<b>,"</b>originalColumnN<b>"</b> [<b>AS</b> aliasN]] <b>FROM</b> tableName</li> 
	[ <b>: { "</b>columnName1<b>", "</b>originalColumn1<b>"</b><b> ,</b>DataType [<b>;"</b>columnName2<b>","</b>originalColumn2<b>",</b>DataType]... [<b>;"</b>columnNameN<b>", "</b>originalColumnN<b>",</b>DataType]<b>}</b>]
<br><br>
<br>An example of the specification above is shown below:
<br><br>
<b>SELECT</b> "A", "B" <b>FROM</b> table : {"a","A",STRING; "b","B",DATE}
<br>
<ul>
<li><i>A</i> and <i>B</i> are the original column names specified in the flatfile or
	<br>generated by the flatfile driver if there is no column name line in flatfile  </li>
<br><br>
<li><i>:</i> in the query-text is the delimiter that seperates the query and the 
 	<br>columns information, and this <i>:</i> should never be double quoted or escaped by <i>\</i></li>
<br><br>
<li>The string between <i>{</i> and <i>}</i> is the saved columns information.
	<br>The information of all saved columns is separated by a <i>semicolon</i>, 
	<br>and the information of each column is separated by a <i>comma</i> 
	<br><i>i.e.</i><i> a</i> is the defined column name of the original column name <i>A</i>,
	<br>and they all should be double quoted, <i>STRING</i> is the data type of this column</li>
<br><br>
<li><b>NOTE:</b> All the delimiters of the query-text: <i><b>:</b></i> , <i><b>;</b></i> , <i><b>{</b></i> , <i><b>}</b></i> 
should never be double quoted, unless they are part of the columns information or the query</li>
</ul>